SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sql_columns](
	[dbms_type_name] [varchar](150) NOT NULL,
	[dbms_name] [varchar](150) NOT NULL,
	[database_name] [varchar](150) NOT NULL,
	[table_schema] [varchar](150) NOT NULL,
	[table_name] [varchar](150) NOT NULL,
	[column_name] [varchar](150) NOT NULL,
	[ordinal_position] [int] NULL,
	[column_default] [varchar](550) NULL,
	[is_identity] [char](5) NULL,
	[is_nullable] [char](5) NULL,
	[data_type] [varchar](150) NULL,
	[character_maximum_length] [int] NULL,
	[character_octet_length] [int] NULL,
	[numeric_precision] [int] NULL,
	[numeric_precision_radix] [int] NULL,
	[numeric_scale] [int] NULL,
	[datetime_precision] [int] NULL,
	[character_set_catalog] [varchar](150) NULL,
	[character_set_schema] [varchar](150) NULL,
	[character_set_name] [varchar](150) NULL,
	[collation_catalog] [varchar](150) NULL,
	[collation_schema] [varchar](150) NULL,
	[collation_name] [varchar](150) NULL,
	[domain_catalog] [varchar](150) NULL,
	[domain_schema] [varchar](150) NULL,
	[domain_name] [varchar](150) NULL,
	[load_dtm] [datetime] NOT NULL,
 CONSTRAINT [PK_sql_columns] PRIMARY KEY CLUSTERED 
(
	[dbms_type_name] ASC,
	[dbms_name] ASC,
	[database_name] ASC,
	[table_schema] ASC,
	[table_name] ASC,
	[column_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IE1sql_columns_dbms_name_IDX] ON [dbo].[sql_columns] 
(
	[dbms_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
